2013-05-02 - 5910.200 - Rel Notes - Contracts - Release 035 #BIReleases2013
Release Notes:
5910.200 - OSA110 - Open Orders by Country and Sales Rep
Admin Info
Purpose
|
Eliminating the Repository function for Fiscal Year and Fiscal Period in OSA110 - Open Orders by Country and Sales Rep.
|
Release No
|
035
|
Submitted
|
05-02-2013
|
Submitted by
|
Mallareddy D
|
Source/Destination Systems
|
IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
|
Release Sent To
|
Mark Harris
|
Object(s) Created By
|
Narendra Koraganji
|
Object(s) Tested By
|
Mallareddy D
|
Report Name
OSA110 - Open Orders by Country and Sales Rep
BEx Query
ZMP_OOCON_Q006
NEC Crystal Reports Standards Check
1. OSA110 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. OSA110 NEC CR checklist has been sent to NEC and also attached here for reference:
OSA110 NEC CR Standard Check List.xlsx
Summary Level Check
Test Conducted
Group 1 : Sales Organization Name : 5th & Ocean Sales
SNo
|
Test Case
|
Value in CR
|
Value in Production 4.0
|
Pass/Fail
|
1
|
No. of Orders
|
736
|
736
|
Pass
|
2
|
Confirmed Quantity
|
1,425,134
|
1,425,134
|
Pass
|
3
|
Sales Org Currency
|
13,496,474
|
13,496,474
|
Pass
|
4
|
Corporate Currency
|
13,496,474
|
13,496,474
|
Pass
|
Group 1 : Sales Organization Name : EMEA Sales
SNo
|
Test Case
|
Value in CR
|
Value in Production 4.0
|
Pass/Fail
|
1
|
No. of Orders
|
8,115
|
8,115
|
Pass
|
2
|
Confirmed Quantity
|
1,809,771
|
1,809,771
|
Pass
|
3
|
Sales Org Currency
|
14,876,674
|
14,876,674
|
Pass
|
4
|
Corporate Currency
|
22,870,258
|
22,870,258
|
Pass
|
Group 1 : Sales Organization Name : United States Sales
SNo
|
Test Case
|
Value in CR
|
Value in Production 4.0
|
Pass/Fail
|
1
|
No. of Orders
|
35,089
|
35,089
|
Pass
|
2
|
Confirmed Quantity
|
11,682,852
|
11,682,852
|
Pass
|
3
|
Sales Org Currency
|
122,674,696
|
122,674,696
|
Pass
|
4
|
Corporate Currency
|
122,674,696
|
122,674,696
|
Pass
|
Second Level Check
Test Conducted
Group 2 : Sales Organization Name > Fiscal Year : APAC Sales > 2012
SNo
|
Test Case
|
Value in CR
|
Value in Production 4.0
|
Pass/Fail
|
1
|
No. of Orders
|
1
|
1
|
Pass
|
2
|
Confirmed Quantity
|
240
|
240
|
Pass
|
3
|
Sales Org Currency
|
26,832
|
26,832
|
Pass
|
4
|
Corporate Currency
|
3,456
|
3,456
|
Pass
|
Group 2 : Sales Organization Name > Fiscal Year : German Sales > 2013
SNo
|
Test Case
|
Value in CR
|
Value in Production 4.0
|
Pass/Fail
|
1
|
No. of Orders
|
14
|
14
|
Pass
|
2
|
Confirmed Quantity
|
2,283
|
2,283
|
Pass
|
3
|
Sales Org Currency
|
25,337
|
25,337
|
Pass
|
4
|
Corporate Currency
|
33,024
|
33,024
|
Pass
|
Third Level Check
Test Conducted
Group 2 : Sales Organization Name > Fiscal Year > Country : EMEA Sales > 2013 > Andorra
SNo
|
Test Case
|
Value in CR
|
Value in Production 4.0
|
Pass/Fail
|
1
|
No. of Orders
|
14
|
14
|
Pass
|
2
|
Confirmed Quantity
|
1,322
|
1,322
|
Pass
|
3
|
Sales Org Currency
|
14,353.18
|
14,353.18
|
Pass
|
4
|
Corporate Currency
|
22,064.62
|
22,064.62
|
Pass
|
Group 2 : Sales Organization Name > Fiscal Year > Country : NEC Korea Sales > 2013 > John Song
SNo
|
Test Case
|
Value in CR
|
Value in Production 4.0
|
Pass/Fail
|
1
|
No. of Orders
|
36
|
36
|
Pass
|
2
|
Confirmed Quantity
|
23,014
|
23,014
|
Pass
|
3
|
Sales Org Currency
|
453,704,944
|
453,704,944
|
Pass
|
4
|
Corporate Currency
|
408,334
|
408,334
|
Pass
|
Fourth Level Check
Test Conducted
Group 2 : Sales Organization Name > Fiscal Year > Country > Sales Group : Mexico Sales > 2013 > Mexico > Alex Noguera
SNo
|
Test Case
|
Value in CR
|
Value in Production 4.0
|
Pass/Fail
|
1
|
No. of Orders
|
126
|
126
|
Pass
|
2
|
Confirmed Quantity
|
276,453
|
276,453
|
Pass
|
3
|
Sales Org Currency
|
59,917,397
|
59,917,397
|
Pass
|
4
|
Corporate Currency
|
4,931,201
|
4,931,201
|
Pass
|
Group 2 : Sales Organization Name > Fiscal Year > Country > Sales Group : EMEA Sales > 2013 > United Kingdom > NE Retail
SNo
|
Test Case
|
Value in CR
|
Value in Production 4.0
|
Pass/Fail
|
1
|
No. of Orders
|
245
|
245
|
Pass
|
2
|
Confirmed Quantity
|
15,697
|
15,697
|
Pass
|
3
|
Sales Org Currency
|
52,536
|
52,536
|
Pass
|
4
|
Corporate Currency
|
80,773
|
80,773
|
Pass
|
Fifth Level Check
Test Conducted
Group 2 : Sales Organization Name > Fiscal Year > Country > Sales Group > Sold-to Party : Latin America Sales > 2013 > Amer.Virgin Is. > Alfredo Alvarez > HABERDASHERS INC DBA URBAN THREADZ - 1008762
SNo
|
Test Case
|
Value in CR
|
Value in Production 4.0
|
Pass/Fail
|
1
|
No. of Orders
|
3
|
3
|
Pass
|
2
|
Confirmed Quantity
|
238
|
238
|
Pass
|
3
|
Customer Currency
|
3,703
|
3,703
|
Pass
|
4
|
Sales Org Currency
|
3,703
|
3,703
|
Pass
|
5
|
Corporate Currency
|
3,703
|
3,703
|
Pass
|
Group 2 : Sales Organization Name > Fiscal Year > Country > Sales Group > Sold-to Party : Australia Sales > 2013 > Australia > David Biwar > EMPIRE DISTRIBUTIONS- 1011384
SNo
|
Test Case
|
Value in CR
|
Value in Production 4.0
|
Pass/Fail
|
1
|
No. of Orders
|
22
|
22
|
Pass
|
2
|
Confirmed Quantity
|
985
|
985
|
Pass
|
3
|
Customer Currency
|
12,285
|
12,285
|
Pass
|
4
|
Sales Org Currency
|
12,285
|
12,285
|
Pass
|
5
|
Corporate Currency
|
12,659
|
12,659
|
Pass
|
Sixth Level Check
Test Conducted
Group 6 : Sales Organization Name > Fiscal Year > Country > Sales Group > Sold-to Party > Sales Order : Canada Sales > 2013 > Canda > Andreq Haqq > ALL SEASONS SOURCE FOR SPORT - 1007146 > 1429729
SNo
|
Test Case
|
Value in CR
|
Value in Production 4.0
|
Pass/Fail
|
1
|
Order Date
|
3/11/13
|
03/11/2013
|
Pass
|
2
|
First Ship
|
4/26/13
|
04/26/2013
|
Pass
|
3
|
Last Ship
|
6/11/13
|
06/11/2013
|
Pass
|
4
|
Cancel Date
|
6/1/13
|
06/01/2013
|
Pass
|
5
|
No. of Orders
|
-
|
-
|
Pass
|
6
|
Confirmed Quantity
|
8
|
8
|
Pass
|
7
|
Customer Currency
|
160
|
160
|
Pass
|
8
|
Sales Org Currency
|
160
|
160
|
Pass
|
9
|
Corporate Currency
|
156
|
156
|
Pass
|
Group 6 : Sales Organization Name > Fiscal Year > Country > Sales Group > Sold-to Party > Sales Order : United States Sales > 2013 > Australia > Brad Chambers > ACUSHNET AUSTRALIA - 1009003 > 1475548
SNo
|
Test Case
|
Value in CR
|
Value in Production 4.0
|
Pass/Fail
|
1
|
Order Date
|
4/19/2012
|
04/19/2012
|
Pass
|
2
|
First Ship
|
6/15/13
|
06/15/2013
|
Pass
|
3
|
Last Ship
|
6/15/13
|
06/15/2013
|
Pass
|
4
|
Cancel Date
|
7/15/13
|
07/15/2013
|
Pass
|
5
|
No. of Orders
|
-
|
-
|
Pass
|
6
|
Confirmed Quantity
|
1,440
|
1,440
|
Pass
|
7
|
Customer Currency
|
6,437
|
6,437
|
Pass
|
8
|
Sales Org Currency
|
6,437
|
6,437
|
Pass
|
9
|
Corporate Currency
|
6,437
|
6,437
|
Pass
|
Seventh Level Check
Test Conducted
Group 6 : Sales Organization Name > Fiscal Year > Country > Sales Group > Sold-to Party > Sales Order > Material : APAC Sales > 2012 > Taiwan > Asian House Accounts > BASE SPORTS CO LTD - 1007206 > 1301537 > 10823679
SNo
|
Test Case
|
Value in CR
|
Value in Production 4.0
|
Pass/Fail
|
1
|
Material No
|
10823679
|
10823679
|
Pass
|
2
|
Description
|
950 NEW ERA FLAG SCARLET
|
950 NEW ERA FLAG SCARLET
|
Pass
|
3
|
Collection Name
|
CUSTOM
|
CUSTOM
|
Pass
|
4
|
Order status
|
-
|
-
|
Pass
|
5
|
Confirmed Quantity
|
60
|
60
|
Pass
|
6
|
Unit Price
|
14
|
14
|
Pass
|
7
|
Customer Currency
|
864
|
864
|
Pass
|
8
|
Sales Org Currency
|
6,708
|
6,708
|
Pass
|
9
|
Corporate Currency
|
864
|
864
|
Pass
|
Reference Document(Specification)
2013-03-15 - 5910.200 - Enhancement - Contract Reports